d836c85fb7e2775c8edff2f97ce232d0cc97eb51,samigo/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/QuestionPoolFacadeQueries.java,QuestionPoolFacadeQueries,getAllPools,#String#,117

Before Change


    // #1.
    // lydial: 9/22/05 we are not really using QuestionPoolAccessData, so filter by ownerid 
    //List poolList = getAllPools(); 
    List poolList = getHibernateTemplate().findByNamedParam("from QuestionPoolData a where a.ownerId = :id", "id", agentId);
/*
    // #2. get all the QuestionPoolAccessData record belonging to the agent
    List questionPoolAccessList = getHibernateTemplate().find(

After Change


            .createQuery("from QuestionPoolData a where a.ownerId = :id")
            .setString("id", agentId)
            .list();
    List<QuestionPoolData> poolList = getHibernateTemplate().execute(hcb);
/*
    // #2. get all the QuestionPoolAccessData record belonging to the agent
    List questionPoolAccessList = getHibernateTemplate().find(